package com.kuwou.workobject.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.kuwou.workobject.pojo.entity.RankList;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface RankListMapper extends BaseMapper<RankList> {

    // 使用 @Select 注解执行 TRUNCATE 语句
    @Select("TRUNCATE TABLE kuwou.`all_rank_list`")
    void truncateTable();

    //获取排行数据
    @Select("select * from all_rank_list")
    List<RankList> getRankData();
}
